Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | |
WorkstationID (AK)(FK) | The unique identifier for the WORKSTATION, typically the serial number. | ID_WS | Identity | integer | Workstation(AS_WS) |
BusinessUnitID (AK)(FK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_BSN_UN | Identity | integer | BusinessUnit(LO_BSN_UN) |
BusinessDayDate (AK)(FK) | The calendar date of the BusinessDay. | DC_DY_BSN | DateCalendar | date | BusinessDay(CA_DY_BSN) |
SequenceNumber (AK) | SequenceNumber is a counter used to uniquely identify individual transaction within a transaction set identified by: BusinessUnit (store or channel location), BusinessDayDate (day this sale/return is attributed to for accounting purposes), WorkstationID (terminal, register where transaction was entered), OperatorID (the cashier or sales associate entering the transaction) and sequence number which exists only to distinguish each transaction. With this in mind, the sequence number is a counter and IS RESET to 1 when a BusinessUnit, BusinessDayDate, WorkstationID, OperatorID control break is encountered. | AI_TRN | Number | integer | |
TransactionTypeCode (FK) | A code to denote the type of Transtion. e.g. RetailTransaction, ControlTransaction, TenderControlTrnsaction, etc... | TY_TRN | Code6 | char(6) | TransactionType(CO_TYP_TRN) |
BeginDateTimestamp | The time and date a transaction is initiated. | TS_TRN_BGN | EffectiveDateTime | datetime | |
EndDateTimestamp | The time and date stamp a transaction is completed. | TS_TRN_END | ExpirationDateTime | datetime | |
CancelledFlag | A flag denoting that this entire transaction has been cancelled before it was completed at the POS. | FL_CNCL | Flag | integer | |
VoidedFlag | A flag denoting that this entire transaction has been voided (and reversed) after it was completed at the POS via a PostVoidTransaction. | FL_VD | Flag | integer | |
SuspendedFlag | A flag denoting that this entire transaction has been suspended before it was completed at the POS. | FL_SPN | Flag | integer | |
TrainingFlag | A flag to signify whether the workstation is in training mode. | FL_TRG_TRN | Flag | integer | |
KeyedOfflineFlag | A code that indiates the online/offline state of how a transaction and its components was entered at a work station. Valid values include 'OL' online, 'SA' Standalone (offline), and 'BO' both online and offline. BO means that some line items (e.g. payment authorizations) were processed online while some (e.g. item scanning/key entry) were done offline. | FL_KY_OFL | Code2 | char(2) | |
RevenueCostCenterID (FK) | A unique retailer assigned identifier for an accounting budget, that owns merchandise and is used to track the financial performance of the retail enterprise. | ID_CTR_RVN_CST | Identity | integer | RevenueCostCenter(CO_CTR_RVN_CST) |
METARWeatherCondiitionID (FK) | Token ID for each METAR Weather condition row. Typically METAR reports are made once per hour per ICAO location. Only locations tied to retailer Sites will have weather conditions reported. Also, retailers may choose to limit the forecasts to once or twice a day. The granularity of weather tracking for retail sales analysis and reporting is less rigorous thant for flight safety and control. | ID_METAR_WTHR_CN | Identity | integer | METARWeatherCondition(CO_METAR_WTHR_CN) |
METARWeatherForecastID (FK) | Token identifier for each instance of a METAR weather forecast entity. Forecast periods, unlike METARWeatherCondition (which are done on an hourly basis or more in volatile weather situations) these cover peirods of multiple days. | ID_METAR_WTHR_FRCST | Identity | integer | METARWeatherForecast(CO_METAR_WTHR_FRCST) |
ForceFlag | A boolean indicator that if set to YES tells the retailer that this ControlTransaction was used to override a standard operating procedure and set a state/status to a desired value. Examples of forced control transactions include: FORCED_SIGNOFF FORCED_SIGNON FORCED_ENDOFDAY_CLOSE etc. The ForceFlag, when set to YES indicates an exception condition that should be reviewed by store operations and internal auditing. | FL_FRCD | Flag | integer | |
LogoID (FK) | A unique, token identifier for a Logo instance. | ID_LGO | Identity | integer | Logo(CO_LGO) |
BatchID | A retailer defined and managed reference to a BATCH used to group transactions for processing purposes. This is an analog for POSLOG6 Batch ID. It is an owned attribute and does not reference another entity. | ID_BTCH | DescriptionShort | varchar(255) | |
SessionID (FK) | A unique token ID for a Session instance. | ID_SSN | Identity | integer | Session(CO_SSN) |